mysql grant remote access to database

The MySQL permissions system revolves around two concepts:Authentication, determining whether a user is allowed to connect to a database serverAuthorization, determines whether the user has sufficient permissions to execute the query request, and so

Grant MySQL account access to specified database under Linux systemRequirements: 1, create a database in MySQL mydata2, new MySQL account admin password 1234563, give the account admin to the database MyData have full operation rights ===============

Transferred from: http://chenling1018.blog.163.com/blog/static/14802542010320112355598/The MySQL permissions system revolves around two concepts:Authentication, determining whether a user is allowed to connect to a database serverAuthorization,

MYSQL adds remote users or allows remote access.Add the remote user admin password as password grant all privileges on *. * TO admin @ localhost identified by \ 'password \ 'with grant option grant all privileges on *. * TO admin @ \ "% \"

Install MySQL1. Download the MySQL Installation FileThe following two files are required to install MYSQL:MySQL-server-5.1.7-0.i386.rpm To download the above two RPM files, locate the "server" and "client programs" items and find the items

Mysql database, remote access to the current mysql database on the server, remote access, do not want to publish the root account, so, created a demo account, allow the demo account to access the shandong database in the mysql database

Install and configure the Mysql database under centos, import the database, authorize a remote ip address, and centos Mysql Uninstall the original mysql Because mysql databases are too popular on Linux, the mainstream Linux system versions currently

　　About MySQL user management, note  1, creating a new user after logging in by the root user creates >> grant all privileges on *. * to [email protected] Identified by  "123456"  ;//create a new user, the user name is TestUser, the password is 12345

Set the user to show database permission firstGrant Select,insert,update,delete on redmine1.* to [e-mail protected]"%" identified by "Jira";Add super permissions and allow remote access:GRANT all privileges on * * to ' myuser ' @ ' 192.168.1.3 '

How to enable the MySQL database remote access permission (two methods), mysql Remote Access Download and install GPL MySQL Community Edition (GPL) Community (GPL) Downloads» When we use the mysql database, sometimes our program and database are not